Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_207

R_207

ResourceItem

DrugDetails

ResourceID

 

 

R_240

R_240

Stock

LStockStock

StockID

 

 

R_241

R_241

Stock

LStockStock

Sto_StockID

 

 

R_242

R_242

StockItem

StockItemQuantity

StockItemID

 

 

R_244

R_244

StockDocument

StockItemQuantity

StockDocumentID

 

 

R_245

R_245

StockDocument

LPersonnelStockDocument

StockDocumentID

 

 

R_246

R_246

Person

LPersonnelStockDocument

PersonID

 

 

R_247

R_247

StockDocumentType

StockDocument

StockDocumentTypeID

 

 

R_248

R_248

StockDocumentType

StockDocumentTypeText

StockDocumentTypeID

 

 

R_250

R_250

SeriesData

StockItemQuantity

SeriesDataID

 

 

R_251

R_251

SeriesData

StockItemQuantityIndex

SeriesDataID

 

 

R_252

R_252

Stock

StockItemQuantityIndex

StockID

 

 

R_253

R_253

StockItem

StockItemQuantityIndex

StockItemID

 

 

R_255

R_255

Stock

StockDocument

StockID

 

 

R_256

R_256

StockDocument

LContractorStockDocument

StockDocumentID

 

 

R_257

R_257

Contractor

LContractorStockDocument

ContractorID

 

 

R_258

R_258

PersonnelFunction

LPersonnelStockDocument

PersonnelFunctionID

 

 

R_267

R_267

ResourceItem

StockItem

ResourceID

 

 

R_268

R_268

StockType

StockTypeText

StockTypeID

 

 

R_276

R_276

PackageType

PackageTypeText

PackageTypeID

 

 

R_277

R_277

Package

PackageText

PackageID

 

 

R_279

R_279

PackageType

Package

PackageTypeID

 

 

R_280

R_280

Package

LPackagePackage

PackageID

 

 

R_281

R_281

Package

LPackagePackage

Pac_PackageID

 

 

R_282

R_282

Package

LPackageUnit

PackageID

 

 

R_283

R_283

Unit

LPackageUnit

UnitID

 

 

R_291

R_291

Producer

StockItem

ProducerID

 

 

R_305

R_305

Unit

ResourceItem

UnitID

 

 

R_311

R_311

Unit

UnitText

UnitID

 

 

R_532

R_532

Patient

OrderItem

PersonID

 

 

R_566

R_566

UnitType

Unit

UnitTypeID

 

 

R_567

R_567

UnitType

UnitTypeText

UnitTypeID

 

 

R_937

R_937

StockItem

StockLimit

StockItemID

 

 

R_938

R_938

Stock

StockLimit

StockID

 

 

R_939

R_939

LimitType

StockLimit

LimitTypeID

 

 

R_953

R_953

Package

StockItemQuantityIndex

PackageID

 

 

R_955

R_955

Package

StockItemQuantity

PackageID

 

 

R_961

R_961

Patient

StockItemQuantityIndex

PersonID

 

 

R_962

R_962

Patient

StockDocument

PersonID

 

 

R_963

R_963

Patient

StockItemQuantity

PersonID

 

 

R_964

R_964

StockItem

LStockItemPackage

StockItemID

 

 

R_965

R_965

StockType

LStockItemPackage

StockTypeID

 

 

R_966

R_966

Package

LStockItemPackage

PackageID

 

 

R_967

R_967

StockPackageType

LStockItemPackage

StockPackageTypeID

 

 

R_968

R_968

StockPackageType

StockPackageTypeText

StockPackageTypeID

 

 

R_978

R_978

StockType

Stock

StockTypeID

 

 

R_1006

R_1006

OrderItem

LOrderStockDocument

OrderID

 

 

R_1007

R_1007

StockDocument

LOrderStockDocument

StockDocumentID

 

 

R_1091

R_1091

StockDocument

LStockDocument

StockDocumentID

 

 

R_1092

R_1092

StockDocument

LStockDocument

Sto_StockDocumentID

 

 


2  3